package top.wardyan.sqlchecker.service.impl;

import top.wardyan.base.common.annotation.Service;
import top.wardyan.base.common.db.service.impl.BaseMasterServiceImpl;
import top.wardyan.sqlchecker.model.YTSqlfile;
import top.wardyan.sqlchecker.service.IYTSqlfileService;


@Service
public class YTSqlfileServiceImpl extends BaseMasterServiceImpl<YTSqlfile> implements IYTSqlfileService{

	
	private static final String SQL_FINDBYMD5 = "SELECT TOP(1) * FROM dbo.yt_sqlfile AS s (NOLOCK) WHERE s.xMD5 = ? ORDER BY s.sID DESC";
	@Override
	public YTSqlfile findByMD5(String md5) {
		return this.findBySql(SQL_FINDBYMD5, md5);
	}

	

	 
}
